Change value formatting of report elements

To apply value formatting for a data-bound control's content (e.g. for it to be treated as currency, or date-time content), locate this control, click on its Smart Tag, and in the actions list, click on the ellipsis button for the Format String entry.

Then, in the displayed Format String Editor, choose one of the predefined formatting styles, or specify a custom one.

 

To quit the dialog and apply the changes, click OK.

Note that when a summary function is being applied to a control's content, value formatting is applied separately, via the Summary Editor, as described in Add totals to a report.

Independently from the general (or summary) value formatting, you can specify a native XLSX format string, which is to be preserved when the report is being exported to XLSX. This can be done via a control's Xlsx Format String property.